	
/****** Object:  Stored Procedure ConPointsInsert    Script Date: Tuesday, October 16, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spConPointsInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spConPointsInsert]
GO

	
	

/******************************************************************************
**		File: 
**		Name: spConPointsInsert
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 10/16/2007 5:29:51 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spConPointsInsert
	@Description nvarchar(50),
	@Goods nvarchar(500),
	@IsDisplayed bit,
	@ContainerLoading nvarchar(500),
	@LoadingPort nvarchar(200),
	@ConPointID int output
AS

INSERT INTO [ConPoints] 
(
	[Description],
	[Goods],
	[IsDisplayed],
	[ContainerLoading],
	[LoadingPort]
) 
VALUES 
(
	@Description,
	@Goods,
	@IsDisplayed,
	@ContainerLoading,
	@LoadingPort
)

SELECT @ConPointID = @@IDENTITY

GO
	
